Skip Headers

Oracle® Data Provider for .NET Developer's Guide 10g Release 2 (10.2) Part Number B14307-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Oracle Data Provider for .NET Assembly

The `Oracle.DataAccess.dll` assembly provides two namespaces:

- The `Oracle.DataAccess.Client` namespace contains ODP.NET classes and enumerations for the client-side provider.

- The `Oracle.DataAccess.Types` namespace contains the Oracle Data Provider for .NET datatypes (ODP.NET Types).

## Oracle.DataAccess.Client Namespace

The `Oracle.DataAccess.Client` namespace contains implementations of core ADO.NET classes and enumerations for ODP.NET, as well as ODP.NET specific classes.

The following tables list ODP.NET classes, enumerations, and types that are supported by the `Oracle.DataAccess.Client` namespace. The tables also indicated which classes are not supported in .NET stored procedures.

### Oracle.DataAccess.Client

Table 1-1 lists the client classes.

Table 1-1 Oracle.DataAccess.Client

Class | Description
--- | ---
OnChangeEventHandler Delegate | The `OnChangedEventHandler` event delegate represents the signature of the method that handles the notification. Not Supported in a .NET Stored Procedure
OracleCommand Class | An `OracleCommand` object represents a SQL command, a stored procedure or function, or a table name.
OracleCommandBuilder Class | An `OracleCommandBuilder` object provides automatic SQL generation for the `OracleDataAdapter` when the database is updated.
OracleConnection Class | An `OracleConnection` object represents a connection to Oracle Database.
OracleDataAdapter Class | An `OracleDataAdapter` object represents a data provider object that communicates with the `DataSet`.
OracleDataReader Class | An `OracleDataReader` object represents a forward-only, read-only, in-memory result set.
OracleDependency Class | An `OracleDependency` class represents a dependency between an application and an Oracle database. Not Supported in a .NET Stored Procedure
OracleError Class | The `OracleError` object represents an error reported by an Oracle database.
OracleErrorCollection Class | An `OracleErrorCollection` object represents a collection of `OracleError`s.
OracleException Class | The `OracleException` object represents an exception that is thrown when Oracle Data Provider for .NET encounters an error.
OracleFailoverEventArgs Class | The `OracleFailoverEventArgs` class provides event data for the `OracleConnection.Failover` event. Not Supported in a .NET Stored Procedure
OracleFailoverEventHandler Delegate | The `OracleFailoverEventHandler` represents the signature of the method that handles the `OracleConnection.Failover` event. Not Supported in a .NET Stored Procedure
OracleGlobalization Class | The `OracleGlobalization` class is used to obtain and set the Oracle globalization settings of the session, thread, and local computer (read-only).
OracleInfoMessageEventArgs Class | The `OracleInfoMessageEventArgs` object provides event data for the `OracleConnection.InfoMessage` event.
OracleInfoMessageEventHandler Delegate | The `OracleInfoMessageEventHandler` delegate represents the signature of the method that handles the `OracleConnection.InfoMessage` event.
OracleNotificationEventArgs Class | The `OnChangedEventArgs` class provides event data for a notification.
OracleNotificationRequest Class | An `OracleNotificationRequest` class represents a notification request to be subscribed in the database. Not Supported in a .NET Stored Procedure
OracleParameter Class | An `OracleParameter` object represents a parameter for an `OracleCommand.`
OracleParameterCollection Class | An `OracleParameterCollection` object represents a collection of `OracleParameter`s.
OracleRowUpdatedEventArgs Class | The `OracleRowUpdatedEventArgs` object provides event data for the `OracleDataAdapter.RowUpdated` event.
OracleRowUpdatedEventHandler Delegate | The `OracleRowUpdatedEventHandler` delegate represents the signature of the method that handles the `OracleDataAdapter.RowUpdated` event.
OracleRowUpdatingEventArgs Class | The `OracleRowUpdatingEventArgs` object provides event data for the `OracleDataAdapter.RowUpdating` event.
OracleRowUpdatingEventHandler Delegate | The `OracleRowUpdatingEventHandler` delegate represents the signature of the method that handles the `OracleDataAdapter.RowUpdating` event.
OracleTransaction Class | An `OracleTransaction` object represents a local transaction. Not Supported in a .NET Stored Procedure
OracleXmlQueryProperties Class | An `OracleXmlQueryProperties` object represents the XML properties used by the `OracleCommand` class when the `XmlCommandType` property is `Query`.
OracleXmlSaveProperties Class | An `OracleXmlSaveProperties` object represents the XML properties used by the `OracleCommand` class when the `XmlCommandType` property is `Insert`, `Update`, or `Delete`.

### Oracle.DataAccess.Client Enumerations

Table 1-2 lists the client enumerations.

Table 1-2 Oracle.DataAccess.Client Enumerations

Enumeration | Description
--- | ---
FailoverEvent Enumeration | `FailoverEvent` enumerated values are used to specify the state of the failover. Not Supported in a .NET Stored Procedure
FailoverReturnCode Enumeration | `FailoverReturnCode` enumerated values are passed back by the application to the ODP.NET provider to request a retry in case of a failover error, or to continue in case of a successful failover. Not Supported in a .NET Stored Procedure
FailoverType Enumeration | `FailoverType` enumerated values are used to indicate the type of failover event that was raised. Not Supported in a .NET Stored Procedure
OracleCollectionType Enumeration | `OracleCollectionType` enumerated values specify whether or not the `OracleParameter` object represents a collection, and if so, specifies the collection type. Not Supported in a .NET Stored Procedure
OracleDbType Enumeration | `OracleDbType` enumerated values are used to explicitly specify the `OracleDbType` of an `OracleParameter`.
OracleNotificationInfo Enumeration | `OracleNotificationInfo` enumerated values specify the database event that causes the notification. Not Supported in a .NET Stored Procedure
OracleNotificationSource Enumeration | `OracleNotificationSource` enumerated values specify the different sources that cause notification. Not Supported in a .NET Stored Procedure
OracleNotificationType Enumeration | `OracleNotificationType` enumerated values specify the different types that cause the notification. Not Supported in a .NET Stored Procedure
OracleParameterStatus Enumeration | The `OracleParameterStatus` enumeration type indicates whether a `NULL` value is fetched from a column, or truncation has occurred during the fetch, or a `NULL` value is to be inserted into a database column.
OracleXmlCommandType Enumeration | The `OracleXmlCommandType` enumeration specifies the values that are allowed for the `OracleXmlCommandType` property of the `OracleCommand` class.

## Oracle.DataAccess.Types Namespace

The `Oracle.DataAccess.Types` namespace provides classes, structures, and exceptions for Oracle native types that can be used with Oracle Data Provider for .NET.

### Oracle.DataAccess.Types Structures

Table 1-3 lists the type structures.

Table 1-3 Oracle.DataAccess.Types Structures

Structure | Description
--- | ---
OracleBinary Structure | The `OracleBinary` structure represents a variable-length stream of binary data.
OracleDate Structure | The `OracleDate` structure represents the Oracle `DATE` datatype.
OracleDecimal Structure | The `OracleDecimal` structure represents an Oracle `NUMBER` in the database or any Oracle numeric value.
OracleIntervalDS Structure | The `OracleIntervalDS` structure represents the Oracle `INTERVAL` `DAY` `TO` `SECOND` datatype.
OracleIntervalYM Structure | The `OracleIntervalYM` structure represents the Oracle `INTERVAL` `YEAR` `TO` `MONTH` datatype.
OracleString Structure | The `OracleString` structure represents a variable-length stream of characters.
OracleTimeStamp Structure | The `OracleTimeStamp` structure represents the Oracle `TimeStamp` datatype.
OracleTimeStampLTZ Structure | The `OracleTimeStampLTZ` structure represents the Oracle `TIMESTAMP` `WITH` `LOCAL` `TIME` `ZONE` datatype.
OracleTimeStampTZ Structure | The `OracleTimeStampTZ` structure represents the Oracle `TIMESTAMP` `WITH` `TIME` `ZONE` datatype.

### Oracle.DataAccess.Types Exceptions

Type Exceptions are thrown only by ODP.NET type structures. Table 1-4 lists the type exceptions.

Table 1-4 Oracle.DataAccess.Types Exceptions

Exception | Description
--- | ---
OracleTypeException Class | The `OracleTypeException` object is the base exception class for handling exceptions that occur in the ODP.NET Types classes.
OracleNullValueException Class | The `OracleNullValueException` represents an exception that is thrown when trying to access an ODP.NET Types structure that is `null`.
OracleTruncateException Class | The `OracleTruncateException` class represents an exception that is thrown when truncation in an ODP.NET Types class occurs.

### Oracle.DataAccess.Types Classes

Table 1-5 lists the type classes.

Table 1-5 Oracle.DataAccess.Types Classes

Class | Description
--- | ---
OracleBFile Class | An `OracleBFile` is an object that has a reference to `BFILE` data. It provides methods for performing operations on `BFILE` objects.
OracleBlob Class | An `OracleBlob` object is an object that has a reference to `BLOB` data. It provides methods for performing operations on `BLOB` objects.
OracleClob Class | An `OracleClob` is an object that has a reference to `CLOB` data. It provides methods for performing operations on `CLOB` objects.
OracleRefCursor Class | An `OracleRefCursor` object represents an Oracle `REF` `CURSOR`.
OracleXmlStream Class | An `OracleXmlStream` object represents a sequential read-only stream of XML data stored in an `OracleXmlType` object.
OracleXmlType Class | An `OracleXmlType` object represents an Oracle `XmlType` instance.